﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'usp_UPDMS_COM_FILE_Get_File_Info_By_Hash_Key')
	BEGIN
		DROP Procedure usp_UPDMS_COM_FILE_Get_File_Info_By_Hash_Key
	END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO

/******************************************************************************
**	Name : usp_UPDMS_COM_FILE_Get_File_Info_By_Hash_Key
**	Desc : 해쉬키로 첨부파일정보 조회
**	Test Exec Query : Exec usp_UPDMS_COM_FILE_Get_File_Info_By_Hash_Key '3D7809E1-19E8-4265-B89E-5F98C46B0507'
**	Called by : All
**	Program ID : All
**	Auth : 송시명
**	Date : 2014-12-09
*******************************************************************************
**	Change History
*******************************************************************************
**	Date:		Author:		Description:
**	--------	--------	---------------------------------------
**						
*******************************************************************************/
CREATE PROC [dbo].[usp_UPDMS_COM_FILE_Get_File_Info_By_Hash_Key]
@hash_key uniqueidentifier
AS
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SET NOCOUNT ON

SELECT File_Dir,
       File_Nm
  FROM UPDMS_COM_FILE WITH(NOLOCK)
 WHERE Hash_Key = @hash_key

GO